2014-02-14 - 11382 - Spec - BI - SA400 changes #CrystalReportsSupport

SPECIFICATION

11382 - BI - SA400 changes

Requirement Summary

---

Need to rebuild SA400 report and remove the spreadsheets that link to it.

Admin Info

---

Purpose	Need to rebuild SA400 report and remove the xls sheets that link to it.
Requested By	Mark Harris
Spec Created By	Praveen Guntuka
Spec Created Date	02/14/2014
Spec QA by	Uday Kumar P
Objects	SA400
Document Status	Complete

References

---

Prior Tickets

None

Documents

None

Functional Requirement

---

1. Initially SA400 report was using Excel sheets as datasources but now we need to replace them by using new BEx query fields.
2. Redesign the report to reduce the usage of Excel files and repository functions in Crystal Reports and to increase the performance.

Solution Summary

---

1. Need to update the source for SA400 report.
2. Need to change the formulas accordingly.
3. Need to restrict 9 series customer in report.

Test Plan

SNo.	Test Scenario	Expected Results
1	Execute the new Crystal Report in Crystal Designer tool after changes.	Report should execute successfully in Crystal Designer tool.
2	Schedule the Crystal Report in NEC Infoview.	Report should execute successfully in NEC Infoview.
3	Validate the report with NEC Enterprise production report.	Report should successfully validate with NEC Enterprise production report

Solution Details

---

1. Need to update the SA400 report datasource.
2. Need to remove the existing excel sheets from the report.
3. Need to change the formulas accordingly.
4. Need to restrict 9 series customers in the report.
5. Need to change the grouping accordingly.
6. Need to check the Cross-tab formatting and fix issues.

Issues

---

None